Model Table ASSET HEALTH HISTORY
Attributes
| Attribute |
Description (where applicable) |
| Asset Group | Represents the Asset Group (Equipment/Linea Asset/Etc.) |
| Asset Health History Count | |
| Asset Id | Asset ID (Object ID for equipment objects, etc) |
| Asset Type | Represents the Type of Asset in the Asset Group |
| Asset_Health | Health Value percentage recorded at Date |
| Dim_Asset_Id | Dimension ID for Asset ID |
| Dim_Asset_Type | Dimension ID for Asset Type |
| Health Seq | Unique sequence number for each recorded health value |
| ID | Key for each Health Value reorded - Combination of Asset Group + Asset Type + Asset ID + Health Seq |
| Mvt_Created_Dt | |
| health_date | Represents the Date and Time which the record was created at |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| ASSET HEALTH HISTORY | FACT_ASSET_HEALTH_HISTORY_TM | FACT_ASSET_HEALTH_HISTORY_BI | FACT_ASSET_HEALTH_HISTORY | On Line |